/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80029
 Source Host           : localhost:3306
 Source Schema         : daka_goods

 Target Server Type    : MySQL
 Target Server Version : 80029
 File Encoding         : 65001

 Date: 15/08/2022 22:57:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for a_user
-- ----------------------------
DROP TABLE IF EXISTS `a_user`;
CREATE TABLE `a_user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `nickname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
  `UnionId` int DEFAULT NULL,
  `in_time` datetime DEFAULT NULL,
  `out_time` datetime DEFAULT NULL,
  `staty_time` datetime DEFAULT NULL COMMENT '停留时间',
  `start_time` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发单开始时间',
  `end_time` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发单结束时间',
  `goods_rest` int DEFAULT NULL COMMENT '商品间隔',
  `img_rest` int DEFAULT NULL COMMENT '图片间隔',
  `fd_status` int DEFAULT '0' COMMENT '发单状态,0关，1开',
  `room_desc` text CHARACTER SET utf8mb3 COLLATE utf8_general_ci COMMENT '欢迎语',
  `at_time` int DEFAULT NULL COMMENT '新人欢迎间隔时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of a_user
-- ----------------------------
BEGIN;
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (1, 'mosheng', '901025', '莫生', 1100, NULL, NULL, NULL, '08:00:00', '22:00:00', 6, 7, 1, '5qyi6L+O5p2l5Yiw8J+RjyBb576k5ZCNXSDvvZ5+Cuivt+aCqOiKsTHliIbpkp/kuobop6PkuIDkuIsK44CQ576k6KeE44CR77yaCiAx77yJ576k5Li75q+P5aSp5Li65a625Lq65Lus5Y+R6YCBSkTlpb3nianllYblk4HvvJsKIDLvvInkurLlj4vku6zlpoLmnpzmnInmjIflrprllYblk4Hnsbvlnovlj6/ku6VAIOe+pOS4u++8jOe+pOS4u+S8muaDs+WKnuazleS4uuWkp+WutuaJvuS8mOaDoOWVhuWTge+8mwogM++8ieWmguaenOaCqOinieW+l+S/oeaBr+aJk+aJsOato+W4uOW3peS9nO+8jOWPr+S7peeCueWHu+e+pOWPs+S4iuinkuiuvue9ruS4uuOAkOa2iOaBr+WFjeaJk+aJsOOAke+8jOS9huaYr+W8uueDiOW7uuiuruiuvue9ruS4uuOAkOe9rumhtuiBiuWkqeOAke+8jOiuqeS8mOaDoOS/oeaBr+abtOmGkuebru+8mwogNO+8ieWQjOaXtuS5n+aBs+ivt+WQhOS9jeS6suWPi+S4jeimgeS5seWPkeW5v+WRiuWSjOaXoOeUqOS/oeaBr++8jOe7tOaKpOWlveWSseS7rOiHquW3seeahOe+pO+8jOWBmuebuOS6suebuOeIseeahOS4gOWutuS6uuOAgg==', 1);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (2, 'admin', '901025', '管理员', 1000130713, NULL, NULL, NULL, '09:00:00', '21:00:00', 10, 7, 1, '5L2g5aW977yMW+aIkOWRmOaYteensF0KIOasoui/juadpeWIsPCfkY8gW+e+pOWQjV0g772eCuivt+aCqOiKsTHliIbpkp/kuobop6PkuIDkuIsK44CQ576k6KeE44CR77yaCiAx77yJ576k5Li75q+P5aSp5Li65a625Lq65Lus5Y+R6YCBSkTlpb3nianllYblk4HvvJsKIDLvvInkurLlj4vku6zlpoLmnpzmnInmjIflrprllYblk4Hnsbvlnovlj6/ku6VAIOe+pOS4u++8jOe+pOS4u+S8muaDs+WKnuazleS4uuWkp+WutuaJvuS8mOaDoOWVhuWTge+8mwogM++8ieWmguaenOaCqOinieW+l+S/oeaBr+aJk+aJsOato+W4uOW3peS9nO+8jOWPr+S7peeCueWHu+e+pOWPs+S4iuinkuiuvue9ruS4uuOAkOa2iOaBr+WFjeaJk+aJsOOAke+8jOS9huaYr+W8uueDiOW7uuiuruiuvue9ruS4uuOAkOe9rumhtuiBiuWkqeOAke+8jOiuqeS8mOaDoOS/oeaBr+abtOmGkuebru+8mwogNO+8ieWQjOaXtuS5n+aBs+ivt+WQhOS9jeS6suWPi+S4jeimgeS5seWPkeW5v+WRiuWSjOaXoOeUqOS/oeaBr++8jOe7tOaKpOWlveWSseS7rOiHquW3seeahOe+pO+8jOWBmuebuOS6suebuOeIseeahOS4gOWutuS6uuOAgg==', 10);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (3, 'doupi', '15069701281', '豆皮', 2025411186, NULL, NULL, NULL, '00:00:00', '23:59:59', 5, 7, 1, 'IOasoui/juadpeWIsPCfkY8gW+e+pOWQjV0g772eCuivt+aCqOiKsTHliIbpkp/kuobop6PkuIDkuIsK44CQ576k6KeE44CR77yaCiAx77yJ576k5Li75q+P5aSp5Li65a625Lq65Lus5Y+R6YCBSkTlpb3nianllYblk4HvvJsKIDLvvInkurLlj4vku6zlpoLmnpzmnInmjIflrprllYblk4Hnsbvlnovlj6/ku6VAIOe+pOS4u++8jOe+pOS4u+S8muaDs+WKnuazleS4uuWkp+WutuaJvuS8mOaDoOWVhuWTge+8mwogM++8ieWmguaenOaCqOinieW+l+S/oeaBr+aJk+aJsOato+W4uOW3peS9nO+8jOWPr+S7peeCueWHu+e+pOWPs+S4iuinkuiuvue9ruS4uuOAkOa2iOaBr+WFjeaJk+aJsOOAke+8jOS9huaYr+W8uueDiOW7uuiuruiuvue9ruS4uuOAkOe9rumhtuiBiuWkqeOAke+8jOiuqeS8mOaDoOS/oeaBr+abtOmGkuebru+8mwogNO+8ieWQjOaXtuS5n+aBs+ivt+WQhOS9jeS6suWPi+S4jeimgeS5seWPkeW5v+WRiuWSjOaXoOeUqOS/oeaBr++8jOe7tOaKpOWlveWSseS7rOiHquW3seeahOe+pO+8jOWBmuebuOS6suebuOeIseeahOS4gOWutuS6uuOAgg==', 1);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (4, 'test', '12346566', '测试账号', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (5, 'zengxiaokang', '1106303599', '曾晓康', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (6, 'jingxin', '363559552', '静心', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (7, 'boanna', 'ligaloes_88', '博安娜', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (8, 'kutie', '462160151', '苦铁', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (9, 'randeng', '18678992', '燃灯', 2010752999, NULL, NULL, NULL, '00:00:00', '23:59:59', 1, 1, 1, '5qyi6L+O77yM6L+b576k6K6w5b6X5byA5YWN5omT5omw77yM572u6aG2576k', 10);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (10, 'suiyue', '896571579', '岁月', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (11, 'bingo708', '851911086', 'EffOrs', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (12, 'zhxi1664', '151676444', '小娴', 1001403986, NULL, NULL, NULL, '09:00:00', '23:30:00', 2, 7, 1, '5L2g5aW977yMW+aIkOWRmOaYteensF0KIOasoui/juadpeWIsPCfkY8gW+e+pOWQjV0g772eCuivt+aCqOiKsTHliIbpkp/kuobop6PkuIDkuIsK44CQ576k6KeE44CR77yaCiAx77yJ576k5Li75q+P5aSp5Li65a625Lq65Lus5Y+R6YCBSkTlj4rnvqTmjqXpvpnnrYnlpb3nianllYblk4HvvJsKIDLvvInkurLlj4vku6zlpoLmnpzmnInmjIflrprllYblk4Hnsbvlnovlj6/ku6VAIOe+pOS4u++8jOe+pOS4u+S8muaDs+WKnuazleS4uuWkp+WutuaJvuS8mOaDoOWVhuWTge+8mwogM++8ieWmguaenOaCqOinieW+l+S/oeaBr+aJk+aJsOato+W4uOW3peS9nO+8jOWPr+S7peeCueWHu+e+pOWPs+S4iuinkuiuvue9ruS4uuOAkOa2iOaBr+WFjeaJk+aJsOOAke+8jOS9huaYr+W8uueDiOW7uuiuruiuvue9ruS4uuOAkOe9rumhtuiBiuWkqeOAke+8jOiuqeS8mOaDoOS/oeaBr+abtOmGkuebru+8mwogNO+8ieWQjOaXtuS5n+aBs+ivt+WQhOS9jeS6suWPi+S4jeimgeS5seWPkeW5v+WRiuWSjOaXoOeUqOS/oeaBr++8jOe7tOaKpOWlveWSseS7rOiHquW3seeahOe+pO+8jOWBmuebuOS6suebuOeIseeahOS4gOWutuS6uuOAgg==', 1);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (13, 'lyddonghao', 'majormedia', '摄卫', 2011503880, NULL, NULL, NULL, '07:00:00', '23:00:00', 10, 7, 1, '5L2g5aW977yMW+aIkOWRmOaYteensF0KIOasoui/juadpeWIsPCfkY8gW+e+pOWQjV0g772eCuivt+aCqOiKsTHliIbpkp/kuobop6PkuIDkuIsK44CQ576k6KeE44CR77yaCiAx77yJ576k5Li75q+P5aSp5Li65a625Lq65Lus5Y+R6YCBSkTlpb3nianllYblk4HvvJsKIDLvvInkurLlj4vku6zlpoLmnpzmnInmjIflrprllYblk4Hnsbvlnovlj6/ku6VAIOe+pOS4u++8jOe+pOS4u+S8muaDs+WKnuazleS4uuWkp+WutuaJvuS8mOaDoOWVhuWTge+8mwogM++8ieWmguaenOaCqOinieW+l+S/oeaBr+aJk+aJsOato+W4uOW3peS9nO+8jOWPr+S7peeCueWHu+e+pOWPs+S4iuinkuiuvue9ruS4uuOAkOa2iOaBr+WFjeaJk+aJsOOAke+8jOS9huaYr+W8uueDiOW7uuiuruiuvue9ruS4uuOAkOe9rumhtuiBiuWkqeOAke+8jOiuqeS8mOaDoOS/oeaBr+abtOmGkuebru+8mwogNO+8ieWQjOaXtuS5n+aBs+ivt+WQhOS9jeS6suWPi+S4jeimgeS5seWPkeW5v+WRiuWSjOaXoOeUqOS/oeaBr++8jOe7tOaKpOWlveWSseS7rOiHquW3seeahOe+pO+8jOWBmuebuOS6suebuOeIseeahOS4gOWutuS6uuOAgg==', 10);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (14, 'zhaochangbox', '714380980', '赵恒', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (15, 'Fruitjun', '937026994', '赵恒', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL);
INSERT INTO `a_user` (`id`, `username`, `password`, `nickname`, `UnionId`, `in_time`, `out_time`, `staty_time`, `start_time`, `end_time`, `goods_rest`, `img_rest`, `fd_status`, `room_desc`, `at_time`) VALUES (16, 'beibei', 'ybb12345678', '贝贝', 1003253876, NULL, NULL, NULL, '00:00:00', '23:59:59', 8, 10, 1, '5qyi6L+O5Yqg5YWl', 1);
COMMIT;

-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
  `wxid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_unicode_ci NOT NULL,
  `nickname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int DEFAULT NULL COMMENT '1发单群 2采集群',
  `PositionId` bigint DEFAULT NULL,
  `Username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of config
-- ----------------------------
BEGIN;
INSERT INTO `config` (`wxid`, `nickname`, `status`, `PositionId`, `Username`) VALUES ('22074450230@chatroom', '5o2h5ryP576kMi3lhajnvZHmgKfku7fmr5TmnIDpq5jnpo/liKnnvqQ=', 1, 222222, 'admin');
INSERT INTO `config` (`wxid`, `nickname`, `status`, `PositionId`, `Username`) VALUES ('15165944926@chatroom', '5o2h5ryP576kLeWFqOe9keaAp+S7t+avlOacgOmrmOemj+WIqee+pA==', 1, 111111, 'admin');
INSERT INTO `config` (`wxid`, `nickname`, `status`, `PositionId`, `Username`) VALUES ('24982285057@chatroom', 'MTExMTExMTExMTEx', 2, NULL, 'mosheng');
INSERT INTO `config` (`wxid`, `nickname`, `status`, `PositionId`, `Username`) VALUES ('21580117114@chatroom', 'VGVlc3Q=', 2, NULL, 'mosheng');
INSERT INTO `config` (`wxid`, `nickname`, `status`, `PositionId`, `Username`) VALUES ('22182413851@chatroom', '8J+QtkpE5bCP5Y+3576k', 2, NULL, 'mosheng');
INSERT INTO `config` (`wxid`, `nickname`, `status`, `PositionId`, `Username`) VALUES ('23457369782@chatroom', '8J+UtPCflLTwn5S05aSn5ZKW6IGa54K56LaF57qnVklQ', 2, NULL, 'mosheng');
INSERT INTO `config` (`wxid`, `nickname`, `status`, `PositionId`, `Username`) VALUES ('25321753706@chatroom', '5Lqs5LicLeWFqOe9keaAp+S7t+avlOacgOmrmOemj+WIqee+pDE=', 1, 1234567, 'mosheng');
INSERT INTO `config` (`wxid`, `nickname`, `status`, `PositionId`, `Username`) VALUES ('22404553432@chatroom', '5Lqs5Lic5q2j5ZOB5YaF6YOo56aP5Yip4pGg576k', 1, 123456, 'mosheng');
INSERT INTO `config` (`wxid`, `nickname`, `status`, `PositionId`, `Username`) VALUES ('24935963214@chatroom', '8J+np/Cfp6flupTlsbFKROWGhemDqOS8mOaDoOWIuA==', 1, 123456, 'mosheng');
INSERT INTO `config` (`wxid`, `nickname`, `status`, `PositionId`, `Username`) VALUES ('23885960164@chatroom', '8J+MniDwn4ye5Lqs5Lic5YaF6YOo56aP5Yip5ZWG5ZOB', 1, 123456, 'mosheng');
INSERT INTO `config` (`wxid`, `nickname`, `status`, `PositionId`, `Username`) VALUES ('24016265617@chatroom', '8J+MniDwn4yeSkTlhoXpg6jnpo/liKnnvqQ=', 1, 123456, 'mosheng');
INSERT INTO `config` (`wxid`, `nickname`, `status`, `PositionId`, `Username`) VALUES ('22074450230@chatroom', '5o2h5ryP576kMi3lhajnvZHmgKfku7fmr5TmnIDpq5jnpo/liKnnvqQ=', 1, 123456, 'mosheng');
INSERT INTO `config` (`wxid`, `nickname`, `status`, `PositionId`, `Username`) VALUES ('15165944926@chatroom', '5o2h5ryP576kLeWFqOe9keaAp+S7t+avlOacgOmrmOemj+WIqee+pA==', 1, 123456, 'mosheng');
COMMIT;

-- ----------------------------
-- Table structure for friends
-- ----------------------------
DROP TABLE IF EXISTS `friends`;
CREATE TABLE `friends` (
  `wxid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_unicode_ci NOT NULL,
  `nickname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_unicode_ci DEFAULT NULL,
  `Username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `wxid` (`wxid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of friends
-- ----------------------------
BEGIN;
INSERT INTO `friends` (`wxid`, `nickname`, `Username`) VALUES ('Taobao@chatroom', '8J+UpeaOqOW5v+e+pDM=', 'mosheng');
INSERT INTO `friends` (`wxid`, `nickname`, `Username`) VALUES ('Runoob@chatroom', '8J+UpeaOqOW5v+e+pDI=', 'mosheng');
INSERT INTO `friends` (`wxid`, `nickname`, `Username`) VALUES ('wx4te4t@chatroom', '8J+UpeaOqOW5v+e+pDE=', 'mosheng');
COMMIT;

-- ----------------------------
-- Table structure for navbar
-- ----------------------------
DROP TABLE IF EXISTS `navbar`;
CREATE TABLE `navbar` (
  `name` varchar(255) COLLATE utf8mb4_zh_0900_as_cs DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_zh_0900_as_cs DEFAULT NULL,
  `class_id` varchar(255) COLLATE utf8mb4_zh_0900_as_cs DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_zh_0900_as_cs;

-- ----------------------------
-- Records of navbar
-- ----------------------------
BEGIN;
INSERT INTO `navbar` (`name`, `url`, `class_id`) VALUES ('待发送商品', '/user/index', 'index');
INSERT INTO `navbar` (`name`, `url`, `class_id`) VALUES ('已发商品', '/user/send', 'send');
INSERT INTO `navbar` (`name`, `url`, `class_id`) VALUES ('添加商品', '/user/add', 'add');
INSERT INTO `navbar` (`name`, `url`, `class_id`) VALUES ('在线选品', '/user/daka_goods', 'daka_goods');
INSERT INTO `navbar` (`name`, `url`, `class_id`) VALUES ('设置发单群', '/user/fd', 'fd');
INSERT INTO `navbar` (`name`, `url`, `class_id`) VALUES ('设置采集群', '/user/cj', 'cj');
INSERT INTO `navbar` (`name`, `url`, `class_id`) VALUES ('设置推广位', '/user/position', 'position');
INSERT INTO `navbar` (`name`, `url`, `class_id`) VALUES ('全局设置', '/user/config', 'config');
COMMIT;

-- ----------------------------
-- Table structure for soft_goods
-- ----------------------------
DROP TABLE IF EXISTS `soft_goods`;
CREATE TABLE `soft_goods` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `status` int DEFAULT NULL COMMENT '0待发送，1已发送，3手动下架，4异常下架',
  `goodsImage` longtext NOT NULL,
  `sucai1` longtext,
  `sucai2` longtext,
  `sucai3` longtext,
  `docment` longtext,
  `upcment` longtext,
  `index` int DEFAULT NULL,
  `in_time` datetime DEFAULT NULL,
  `up_time` datetime DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=15830 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of soft_goods
-- ----------------------------
BEGIN;
INSERT INTO `soft_goods` (`ID`, `status`, `goodsImage`, `sucai1`, `sucai2`, `sucai3`, `docment`, `upcment`, `index`, `in_time`, `up_time`, `username`) VALUES (1, 1, 'https://img14.360buyimg.com/pop/jfs/t1/93278/15/24684/176081/6241432dE27333e1a/bac8f3cc3ab92dfa.jpg', '', '', '', '44CQ8J+UtDE1LjnlhYPljIXpgq7jgJHmtIHmiJAg6aOf5ZOB5a+G5bCB6KKL57uE5ZCI6KOFIOWwj+WPtyvlsI/lj7cr5Lit5Y+3IOWFsTc15Y+qCgpodHRwczovL3UuamQuY29tL1R3bExvZGU=', NULL, 1, '2022-03-31 23:53:09', '2022-04-03 21:59:57', 'mosheng');
INSERT INTO `soft_goods` (`ID`, `status`, `goodsImage`, `sucai1`, `sucai2`, `sucai3`, `docment`, `upcment`, `index`, `in_time`, `up_time`, `username`) VALUES (2, 1, 'http://static.dakabl.com/upload/2022-03-31/559dc8d8-2437-449e-a644-fc49f5311e3c_o.jpg', '', '', '', '8J+RmfCfkZnogZrmi6LmnInlnovnqb/lh7rnvo7og7jvvIHwn5GN5p+U6L2v5Lqy6IKk77yM6IiS6YCC6KO45oSf5LiA5pW05aSp77yBCgrinIXliqDlrr3liqDlnKjlupXlm7TvvIzlj6/mi4bljbjlhoXmna/wn5Cs5ruh6Laz5LiN5ZCM6ZyA5rGC77yBCgrjgJBKROWVhuWfjuOAkeS8iuaDheWmriDml6Dnl5Xov5Dliqjmlofog7jCoOWbm+iJsuWPr+mAiQrigJTigJTigJTigJTigJTigJTigJTigJQK5Y6f5Lu377yawqU3OQrliLjlkI7vvJrCpTM5CvCfkYnmiqLotK3vvJpodHRwczovL3UuamQuY29tL1dDdExibGM=', '', 15804, '2022-04-03 21:59:41', '2022-04-03 22:11:07', 'mosheng');
INSERT INTO `soft_goods` (`ID`, `status`, `goodsImage`, `sucai1`, `sucai2`, `sucai3`, `docment`, `upcment`, `index`, `in_time`, `up_time`, `username`) VALUES (3, 1, 'http://static.dakabl.com/upload/2022-03-30/e0283fb7-997b-48f6-a2b5-033b783d2892_o.jpg', '', '', '', '8J+SquS8kemXsuaXtuWIu+adpeS4gOadr++8jOeUhOmAiTnnp43ljp/mlpnirZXvuI/mu4vmtqblm5vlraMg5a+55oqX5pel5bi44oCc5bCP54Gr5rCU4oCdwqAKCuOAkEpE5peX6Iiw5bqX44CR5byg5aSq5ZKMIOazoembquaiqOerueiUl+iMheagueiMtioy55uSCuKAlOKAlOKAlOKAlOKAlOKAlOKAlOKAlArljp/ku7fvvJrCpTEzOS44CuWIuOWQju+8msKlNjkuOArwn5GJ5oqi6LSt77yaaHR0cHM6Ly91LmpkLmNvbS9UdGhoUWxK', '', 15805, '2022-04-03 21:59:42', '2022-04-03 22:12:34', 'mosheng');
INSERT INTO `soft_goods` (`ID`, `status`, `goodsImage`, `sucai1`, `sucai2`, `sucai3`, `docment`, `upcment`, `index`, `in_time`, `up_time`, `username`) VALUES (4, 1, 'http://static.dakabl.com/upload/2022-03-30/9a0e6d31-06b6-40bd-acab-6426c469cd9e_o.jpg', '', '', '', '4q2V77iPNOWRs+S4reiNr+mFjeaWue+8jOenkeWtpumFjeavlO+8jOWHj+aOieawtOahtuiFsPCfjYDoibLms73ph5Hpu4TvvIzlm57lkbPnlJjnlJzvvIzni6znq4vojLbljIXpmo/lv4Pms6HvvIEKCuKcheWkqeWkqeS4gOiii++8jOe+jumjn+eYpui6q+S4pOS4jeivr++8gQoK44CQSkTml5foiLDlupfjgJHlvKDlpKrlkowg5Yas55Oc6I235Y+26Iy2MTIwZyoz55uSCuKAlOKAlOKAlOKAlOKAlOKAlOKAlOKAlArljp/ku7fvvJrCpTc5LjkK5Yi45ZCO77yawqUyOS458J+JkDPnm5IK8J+RieaKoui0re+8mmh0dHBzOi8vdS5qZC5jb20vV0x0ZDBPdg==', '', 15806, '2022-04-03 21:59:44', '2022-04-03 22:16:29', 'mosheng');
INSERT INTO `soft_goods` (`ID`, `status`, `goodsImage`, `sucai1`, `sucai2`, `sucai3`, `docment`, `upcment`, `index`, `in_time`, `up_time`, `username`) VALUES (5, 0, 'http://static.dakabl.com/upload/2022-04-01/ae66a6f9-8180-431f-acd6-b289702bec0a_o.jpg', '', '', '', '4oCU4oCU5rGk6Iej5YCN5YGl77yB4oCU4oCUDQoNCvCfkqrpkpnpk4HplIzkuInmoLflkIzooaXvvIzliqnlipvpnZLlsJHlubTmiJDplb/vvIEKCuOAkEpE5peX6Iiw5bqX44CR5rGk6Iej5YCN5YGlIOmSmemTgemUjOWavOeJh8KgM+ebkiozMOeJhwrigJTigJTigJTigJTigJTigJTigJTigJQK5Y6f5Lu377yawqUxOTkK5Yi45ZCO77yawqU0OfCfiZAz55uS4p2X77iP6YCB6L+Q6LS56ZmpCvCfkYnmiqLotK3vvJpodHRwczovL3UuamQuY29tL1d0dENwb1o=', '', 15803, '2022-04-03 21:59:46', NULL, 'mosheng');
INSERT INTO `soft_goods` (`ID`, `status`, `goodsImage`, `sucai1`, `sucai2`, `sucai3`, `docment`, `upcment`, `index`, `in_time`, `up_time`, `username`) VALUES (6, 0, 'http://static.dakabl.com/upload/2022-03-31/7ab9d378-a741-422f-882c-b59d84601517_o.jpg', '', '', '', '4oCU4oCU5Lmw5LiA6YCB5LiA77yM6LaF5pyJ5pWI4oCU4oCUCgrjgJBKROWVhuWfjuOAkeWNl+S6rOWQjOS7geWggiDnvo7nmb3npZvmlpHpnJwgMzBnKjLmlK8KCvCfkrAzOS4w5YWDCmh0dHBzOi8vdS5qZC5jb20vV3d0SWJ2UArwn5S05Zu95aaG54m56K+B77yBClvmgZDmg6dd5aSq5aS45byg5LqG77yM5pWI5p6c5aW95b6X5YOP5pW05a6577yB5Y675pqX5rKJ5Lqu6IKk6Imy77yM5LiA55O25aSa5pWI5pS55ZaE5ZCE56eN5paRCg==', '', 15818, '2022-04-03 21:59:46', NULL, 'mosheng');
INSERT INTO `soft_goods` (`ID`, `status`, `goodsImage`, `sucai1`, `sucai2`, `sucai3`, `docment`, `upcment`, `index`, `in_time`, `up_time`, `username`) VALUES (7, 3, 'http://static.dakabl.com/upload/2022-04-01/fee5e53f-a7c8-407b-9f2a-f07cd9e41a62_o.jpg', '', '', '', '4oCU4oCU5aKe5by65YWN55ar5Yqb77yB4oCU4oCUCgrinaTvuI9R54mI5ryr5aiB6Iux6ZuEK+iQjOiQjOWwj+eGiumAoOWeiwrwn5GN5reh5reh5aW26aaZ5ZGz77yM5a2p5a2Q5ZCD5LqG6L+Y5oOz5ZCD77yBCgrjgJBKROaXl+iIsOW6l+OAkeaxpOiHo+WAjeWBpSDniZvliJ3kubPliqDpkpnlkoDlmrzniYcgM+eTtiozMOeJhwrigJTigJTigJTigJTigJTigJTigJTigJQK5Y6f5Lu377yawqUxOTkK5Yi45ZCO77yawqU0OfCfiZAz55O24p2X77iP6YCB6L+Q6LS56ZmpCvCfkYnmiqLotK3vvJpodHRwczovL3UuamQuY29tL1R3aHhUQzc=', '', 15800, '2022-04-03 21:59:48', NULL, 'mosheng');
INSERT INTO `soft_goods` (`ID`, `status`, `goodsImage`, `sucai1`, `sucai2`, `sucai3`, `docment`, `upcment`, `index`, `in_time`, `up_time`, `username`) VALUES (8, 1, 'http://img.jtke.net/vx_img/2022-04-03-22-12-56_2.jpg', 'http://img.jtke.net/vx_img/2022-04-03-22-12-57_1.jpg', 'http://img.jtke.net/vx_img/2022-04-03-22-12-59_3.mp4', '', '8J+YjeiQpeWFu+aXqemkkOadpeS6hu+8jDPliIbpkp/mkJ7lrprvvIEKCuOAkOeah+WRs+OAkeaguOahg+iKnem6u+m7keixhueyiSAKCjE3Ljnlvpc2MDBnKjHnvZAKaHR0cHM6Ly91LmpkLmNvbS9UTW9zR2VR', '5omR6by755qE6aaZ77yB5piT5Yay5rOh77yB5omT5bCP5bCx5ZCs6K+06buR6Iqd6bq757KJ5aSa5ZCD5a+56Lqr5L2T54m55Yir5aSa5aW95aSE77yB6L+Z5LmI5aSn5YiG6YeP77yB5a6J5o6S8J+YmA==', 15805, '2022-04-03 22:13:21', '2022-04-03 22:15:02', 'mosheng');
INSERT INTO `soft_goods` (`ID`, `status`, `goodsImage`, `sucai1`, `sucai2`, `sucai3`, `docment`, `upcment`, `index`, `in_time`, `up_time`, `username`) VALUES (15822, 0, 'https://img14.360buyimg.com/pop/jfs/t1/36588/8/16695/130420/62beaca9Efd7bcfa6/293f03acb427092d.jpg', '', '', '', '4oCU4oCU56ul6KOF6KGl6LS057un57ut4oCU4oCUCgrlhYjpooYy5byg5Yi4OgpodHRwOi8vNG84LmNuLzE5V0MxSgpodHRwOi8vNG84LmNuLzF4ZnA3dAoKQTIxIOWEv+erpeefreiillTmgaTooavvvIjnlLflpbPnq6XmrL7lnYfmnInvvIkKCmh0dHBzOi8vdS5qZC5jb20vSE03dDBHQQrigJTigJQK8J+UtOS7u+mAiTPku7bliqDotK3nu5Pnrpc1OeWFg++8m+aJjeaKmDE5LjblhYMv5Lu2Cgoq5Y+j56KR5aW95bqX77yM5ZOB6LSo5b6I6LWe77yM5aSa5qy+5byP5Y+v6YCJ77yB5omL5oWi5pat56CB4o+w5Zuk6LW377yB', '8J+UpeerpeijheeIhuasvuadpeiire+8ge+8gQrwn5Sl5Yay77yB77yB77yB77yB77yB77yB77yB77yB', 15809, '2022-08-02 14:41:17', NULL, 'mosheng');
INSERT INTO `soft_goods` (`ID`, `status`, `goodsImage`, `sucai1`, `sucai2`, `sucai3`, `docment`, `upcment`, `index`, `in_time`, `up_time`, `username`) VALUES (15821, 3, 'http://localhost:83/uploads/images/2022-08-02-12-43-12_564b7c2a19ef595adb7f67b649218b8f%20(1).png', 'http://localhost:83/uploads/images/2022-08-02-12-43-12_564b7c2a19ef595adb7f67b649218b8f.png', 'http://localhost:83/uploads/images/2022-04-03-22-12-59_3.mp4', '', 'MzI1MzM0NQ==', 'NDUzNA==', 15805, '2022-08-02 12:43:16', NULL, 'mosheng');
INSERT INTO `soft_goods` (`ID`, `status`, `goodsImage`, `sucai1`, `sucai2`, `sucai3`, `docment`, `upcment`, `index`, `in_time`, `up_time`, `username`) VALUES (15820, 3, 'http://static.dakabl.com/upload/2022-07-21/295ffa00-a34a-41ad-8a13-688cd6206aef_o.jpg', '', '', '', '8J+SpeeIhuasvuS9juS7t+adpeiirfCfkp3pgIHlpbPlj4vnmoTkuI3kuozkuYvpgInvvIEKCvCfjIjnjpvnkZnlnIbmtqblhYnmu5HvvIzogJDno6jlj4jnmb7mkK3vvIEKCuOAkEpE5peX6Iiw5bqX44CR6Iqx5aW9546J57yYIOe6oueOm+eRmemhuemTvuaJi+mTvsKgCuKAlOKAlOKAlOKAlOKAlOKAlOKAlOKAlArljp/ku7fvvJrCpTIxNy45CuWIuOWQju+8msKlMzkuOQrwn5GJ5oqi6LSt77yaaHR0cHM6Ly91LmpkLmNvbS9IdDdhNTRK', '', 15801, '2022-08-01 16:48:52', NULL, 'mosheng');
INSERT INTO `soft_goods` (`ID`, `status`, `goodsImage`, `sucai1`, `sucai2`, `sucai3`, `docment`, `upcment`, `index`, `in_time`, `up_time`, `username`) VALUES (15819, 3, 'http://static.dakabl.com/upload/2022-07-29/9bb65f90-b0fb-4790-87fd-37b889b600c0_o.jpg', '', '', '', '4oCU4oCU55m+5ZCD5LiN5Y6M4oCU4oCUCgrjgJBKROaXl+iIsOW6l+OAkeWwj+eGiumpvuWIsCAg55Wq6IyE6IKJ6YWx5oSP6Z2iMjE1ZwrigJTigJTigJTigJTigJTigJTigJTigJQK5YaF6LSt5Lu377yawqUzOS4zNi/lm5vku7bwn4mQNOebkgrCpXvlhoXotK3ku7d9CuKRoOmihuWIuO+8mmh0dHBzOi8vdS5qZC5jb20vSENTU2wxQiAK4pGh5oqi6LSt77yaaHR0cHM6Ly91LmpkLmNvbS9IZDcyY1pwCuKAlOKAlOKAlOKAlOKAlOKAlOKAlOKAlArimqDvuI/kuIDlrprmi4005Lu277yM5YaF6YWN6YWx5YyF8J+NtOi9u+advuaQnuWumumkkOWOheWQjOasvuaEj+mdou+8gQ==', '', 15820, '2022-08-01 16:47:50', NULL, 'mosheng');
INSERT INTO `soft_goods` (`ID`, `status`, `goodsImage`, `sucai1`, `sucai2`, `sucai3`, `docment`, `upcment`, `index`, `in_time`, `up_time`, `username`) VALUES (15818, 0, 'http://localhost:83/uploads/images/2022-07-31-10-52-49_imgtest.png', '', '', '', '6JmO6YKm6bKB6KW/54mb6IKJ6YWxCjMwZyoxMue9kApodHRwczovL3UuamQuY29tL0hkbGpGNnoK4oCU4oCU4oCUCuWIuOWQjjE5LjnlhYNb54ix5b+DXeeJueWlveWQgwoKKuS4gOasoeS4gOadr++8jOaLjOmlreaLjOmdouacieWug+WwseWkn+S6hn4g', '', 15819, '2022-07-31 10:53:01', NULL, 'mosheng');
INSERT INTO `soft_goods` (`ID`, `status`, `goodsImage`, `sucai1`, `sucai2`, `sucai3`, `docment`, `upcment`, `index`, `in_time`, `up_time`, `username`) VALUES (15829, 1, 'https://img14.360buyimg.com/pop/jfs/t1/90548/8/31785/103940/62f360f7E4ef80758/4b08f83f1cd081d6.jpg', NULL, NULL, NULL, '77+lMTIuOfCfiZDliqDljprmh5LkurrmirnluIMgNDAw5bygCuS6rOS4nPCfkYlodHRwczovL3UuamQuY29tL1JkVnNPMXoKCuW5sua5v+S4pOeUqO+8jOmjn+WTgee6p++8jOWPr+awtOa0lwrnnJ/mraPliqDljprvvIzlkLjmsLTlkLjmsrnvvIzovbvmnb7ljrvmsaE=', NULL, 15829, '2022-08-15 22:09:53', NULL, 'mosheng');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
